<!DOCTYPE html>
<html class="x-admin-sm">

<head>
    <meta charset="UTF-8">
    <title>宿舍管理系统</title>
    <meta name="renderer" content="webkit">
    <meta name="csrf-token" content="{{ csrf_token() }}" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
    <meta name="viewport"
        content="width=device-width,user-scalable=yes, minimum-scale=0.4, initial-scale=0.8,target-densitydpi=low-dpi" />
    <link rel="stylesheet" href="{{ asset('css/font.css') }}">
    <link rel="stylesheet" href="{{ asset('css/xadmin.css') }}">
    <script src="{{ asset('lib/layui/layui.js') }}" charset="utf-8"></script>
    <script type="text/javascript" src="{{ asset('js/xadmin.js') }}"></script>
    <!--[if lt IE 9]>
    <script src="https://cdn.staticfile.org/html5shiv/r29/html5.min.js"></script>
    <script src="https://cdn.staticfile.org/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>

<body>
    <div class="x-nav">
        <span class="layui-breadcrumb">
            <a href="/home">首页</a>
            <a>
                <cite>表管理记录</cite></a>
        </span>
        <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right"
            onclick="location.reload()" title="刷新">
            <i class="layui-icon layui-icon-refresh" style="line-height:30px"></i></a>
    </div>
    <div class="layui-fluid">
        <div class="layui-row layui-col-space15">
            <div class="layui-col-md12">
                <div class="layui-card">
                    <div class="layui-card-body ">
                        <form class="layui-form layui-col-space5">
                            <div class="layui-inline layui-show-xs-block">
                                <input class="layui-input" autocomplete="off" placeholder="开始日" name="start"
                                    id="start" value="{{ old('start') }}">
                            </div>
                            <div class="layui-inline layui-show-xs-block">
                                <input class="layui-input" autocomplete="off" placeholder="截止日" name="end"
                                    id="end" value="{{ old('end') }}">
                            </div>
                            <div class="layui-inline layui-show-xs-block">
                                <input type="text" name="dorm-code" placeholder="请输入宿舍号" autocomplete="off"
                                    class="layui-input" value="{{ old('dorm-code') }}">
                            </div>
                            <div class="layui-inline layui-show-xs-block">
                                <button class="layui-btn" lay-submit="" lay-filter="search"><i
                                        class="layui-icon">&#xe615;</i></button>
                            </div>
                        </form>
                    </div>
                    <div class="layui-card-body layui-table-body layui-table-main">
                        <table class="layui-hide" id="test" lay-filter="test"></table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</body>
<script type="text/html" id="barDemo">
    @{{# if(d.dorm_id) { }}
    <a class="layui-btn layui-btn-normal layui-btn-xs" lay-event="replace_dorm">更换宿舍</a>
    @{{# }else{ }}
    <a class="layui-btn layui-btn-xs" lay-event="set_dorm">安排宿舍</a>
    @{{# } }}
</script>
<script>
    layui.use(['table', 'laydate', 'form'], function() {
        var laydate = layui.laydate;
        //执行一个laydate实例
        laydate.render({
            elem: '#start' //指定元素
        });

        //执行一个laydate实例
        laydate.render({
            elem: '#end' //指定元素
        });
        let b = build_criteria();
        let q = asm_query(b)
        let total = 0;
        var table = layui.table;
        table.render({
            elem: '#test',
            url: `/dorm-meter-adjusts?${q}`,
            toolbar: true,
            title: '表管理记录',
            cols: [
                [{
                    type: 'checkbox'
                }, {
                    field: 'id',
                    title: 'ID',
                    width: 80,
                    unresize: true,
                    hide: true
                }, {
                    field: 'company',
                    title: '公司',
                    width: 100,
                    templet: function(d) {
                        return d.company.short_name || d.company.name;
                    },
                    hide: {{ Auth::user()->is_super ? 'false' : 'true' }}
                }, {
                    field: 'dorm_code',
                    title: '宿舍号',
                    width: 100,
                    sort: true,
                    templet: function(d) {
                        return d.dorm?.code || '';
                    }
                }, {
                    field: 'meter_type',
                    title: '表类型',
                    width: 100,
                    sort: true,
                    templet: function(d) {
                        return d.meter_type?.name || '';
                    }
                }, {
                    field: 'dorm_meter_old',
                    title: '旧表TID',
                    width: 100,
                    templet: function(d) {
                        return d.dorm_meter_old?.nfc_id || '';
                    }
                }, {
                    field: 'dorm_meter_new',
                    title: '新表TID',
                    width: 100,
                    templet: function(d) {
                        return d.dorm_meter_new?.nfc_id || '';
                    }
                }, {
                    field: 'adjust_type',
                    title: '管理类型',
                    width: 100
                }, {
                    field: 'adjust_date',
                    title: '执行日期',
                    width: 100,
                    sort: true
                }, {
                    field: 'remark',
                    title: '备注',
                    width: 120
                }, {
                    field: 'created_at',
                    title: '创建时间',
                    width: 150,
                    sort: true
                }, {
                    field: 'updated_at',
                    title: '更新时间',
                    width: 150,
                    sort: true
                }]
            ],
            autoSort: false,
            initSort: {
                field: 'updated_at',
                type: 'desc'
            },
            page: true,
            limit: 20,
            limits: [20, 40, 80, 160, 320, 640, 1280],
            parseData: function(res) { //将原始数据解析成 table 组件所规定的数据
                total = res.data.total
                return {
                    "code": 0, //解析接口状态
                    "msg": "", //解析提示文本
                    "count": total, //解析数据长度
                    "data": res.data.data //解析数据列表
                };
            }
        });
        // 触发排序事件
        table.on('sort(test)', function(obj) { //注：sort 是工具条事件名，test 是 table 原始容器的属性 lay-filter="对应的值"
            if (obj.field === 'meter_type') {
                obj.field = 'meter_type_id'
            } else if (obj.field === 'dorm_code') {
                obj.field = 'dorm_id'
            }
            table.reload('test', {
                initSort: obj //记录初始排序，如果不设的话，将无法标记表头的排序状态。
                    ,
                where: { //请求参数（注意：这里面的参数可任意定义，并非下面固定的格式）
                    search: b.criteria,
                    searchFields: b.oprt,
                    searchJoin: 'and',
                    orderBy: obj.field //排序字段
                        ,
                    sortedBy: obj.type //排序方式
                }
            });
        });


        let form = layui.form;
        form.on('submit(search)', function(data) {
            b = build_criteria()
            q = asm_query(b)
            table.reload('test', {
                url: '/dorm-meter-adjusts',
                where: {
                    search: b.criteria,
                    searchFields: b.oprt,
                    searchJoin: 'and'
                },
                page: {
                    curr: 1 //重新从第 1 页开始
                }
            });
            return false;
        });


    });

    /*类型-删除*/
    function del_one(obj, id) {
        $.ajaxSetup({
            headers: {
                'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
            }
        });
        $.ajax({
            url: 'dorm-meter-records/' + id,
            type: 'DELETE',
            dataType: "json",
            success: function() {
                layer.msg(`已删除${id}!`, {
                    icon: 1,
                    time: 1000
                });
                if (obj) {
                    $(obj).parents("tr").remove();
                }
            },
            error: function(err) {
                layer.msg('删除失败', {
                    icon: 2,
                    time: 1000
                });
            }
        });
    }

    function build_criteria() {
        let start = $("[name='start']").val();
        let end = $("[name='end']").val();
        let dormCode = $("[name='dorm-code']").val();
        let criteria = '';
        let oprt = '';
        if (start && end) {
            criteria += `created_at:${start},${end} 23:59:59;`;
            oprt += 'created_at:between;';
        } else {
            if (start) {
                criteria += `created_at:${start};`;
                oprt += 'created_at:>;'
            }
            if (end) {
                criteria += `created_at:${end} 23:59:59;`;
                oprt += 'created_at:<=;';
            }
        }
        if (dormCode) {
            criteria += `dorm.code:${dormCode};`;
            oprt += 'dorm.code:=;';
        }
        return {
            criteria,
            oprt
        }
    }

    function asm_query(build_criteria, order = 'updated_at', sort = 'desc') {
        return `search=${build_criteria.criteria}&searchFields=${build_criteria.oprt}&searchJoin=and&orderBy=${order}&sortedBy=${sort}`
    }
</script>

</html>
